Database overviewWhat is DataSymbolic records describing things are called dataWhat is a databaseThe database is the warehouse where the data is stored, except that the warehouse is on a computer storage device, and the data is stored in a certain
Since the introduction of the relational database model by edugatd in 1970, relational databases began to emerge. After more than 40 years of evolution, today's relational databases have a wide variety of features and are widely used. In the face of
This article lists the MySQL data type list, which consists of five main categories: integer type, floating-point type, String type, date type, and other data types, which are explained in detail in the following five data types. There are also the
Lead
Practical experience from the frontline
There's a bloody lesson behind every military rule.
Do not be gorgeous, as long as practical
If there's one that benefits you, you'll be comforting.
Primarily for database
* Operation of the library (increase and deletion check)I. System databaseView system library commands show databases1.information_schema:Virtual library, does not occupy disk space, storage is the database startup parameters, such as user table
[Mysql] database usage specifications, mysql database specificationsI. MySQL Problems
The optimizer does not support complex SQL statements.
Poor Support for SQL standards
The large-scale cluster solution is not mature, mainly refers to
1 Overall knowledge introduction : MySQL basic operation and use, MySQL optimization (index, sub-table, etc.), MySQL deployment (read/write separation, load balancing, etc.)Database Basic Introduction : Database concept, common database, Web
How to choose the right storage engineFeatures of several common storage enginesHere we focus on several common storage engines and compare the differences and recommended usage between each storage engine.Features
I. Problems with MySQL
Optimizer does not support complex SQL
Poor support for SQL standard
Large-scale cluster scheme is immature, mainly refers to middleware
ID generator, global self-increment ID
Asynchronous logical
MySQL data types can be categorized into three categories, namely, numeric data types, string data types, and datetime data types.Numeric data typeNumeric types can also be classified as Integer, floating-point type, Decimal.Integral typeThe MySQL
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.